Skip Headers

Oracle® Database SQL Reference 10g Release 2 (10.2) Part Number B14200-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# RAWTONHEX

Syntax

Description of the illustration rawtonhex.gif

Purpose

`RAWTONHEX` converts `raw` to an `NVARCHAR2` character value containing its hexadecimal equivalent. The value returned is always in the national character set.

Examples

The following hypothetical example returns the hexadecimal equivalent of a `RAW` column value:

    SELECT RAWTONHEX(raw_column),
       DUMP ( RAWTONHEX (raw_column) ) "DUMP"
       FROM graphics;

    RAWTONHEX(RA)           DUMP
    ----------------------- ------------------------------
    7D                      Typ=1 Len=4: 0,55,0,68